Hệ thống quản lý trường học bằng PHP / MySQLi

exportstudentlist.php
school_management_system /
project /

1 <?php
2 SESSION_START();
3 ?>
4 <!DOCTYPE html>
5 <html>
6
7 <head>
8     <meta charset="utf-8">
9     <meta name="viewport" content="width=device-width, initial-scale=1.0">
10     <title>school management system</title>
11     <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
12     <link rel="stylesheet" href="assets/css/bootstrap.min.css">
13     <link href="assets/css/loader.css" rel="stylesheet" />
14     <script src="assets/js/canvasjs.min.js"></script>
15     
16     <script src="assets/js/jquery-3.2.1.js"></script>
17 </head>
18
19 <body >
20 
21 <ul class="nav navbar-right top-nav">
22     <div class="dropdown">
23   <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
24   <?php
25         //Check to see if the user is logged in.if not redirect user to the loging page.
26
27         if(isset($_SESSION['fname']))
28         {
29         echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
30         }else{
31           echo "<script type='text/javascript'>
32                     alert( 'You must Log in to use the system');
33                     </script>";
34                 echo "<script>
35                     window.location = 'index.php'
36                   </script>";
37         }
38         ?>
39   <span class="caret"></span></button>
40   <ul class="dropdown-menu">
41       <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
42       <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
43       <li class="divider"></li>
44       <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
45   </ul>
46 </div>
47   </ul>
48 
49 <div style="
50     font-family:Nyala, Arial;
51     text-align: left;
52     background-color: #526F35;
53     padding: 20px;
54     color:white;
55     width: 100%;
56     height: 150px;">
57     
58     <div id="loading">
59             <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
60     </div>
61 
62     <h2>
63             <?php
64             $sql="SELECT * FROM companyinfo";
65             $result=mysqli_query($db,$sql) or die("error getting data");
66             $num_rows=mysqli_num_rows($result);
67              while($row=mysqli_fetch_array($result))
68                     {
69                     echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
70                     $cname = $row['cname'];
71                      $cemail = $row['cemail'];
72                       $ccontact = $row['ccontact'];
73                        $clocation = $row['clocation'];
74                     }?>
75                     <?php
76                     echo $cname;
77                     ?>
78
79     <div style="float:right; font-size:20px;text-align:right;">
80
81     <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
82     <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
83     <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
84
85     </div>
86    </h2>
87 </div>
88 
89
90
91     <div>
92         <ul class="nav nav-tabs">
93             <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
94             <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
95             <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
96             <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
97             <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
98             <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
99             <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
100             <li><a href="parents.php">Visitors <img src="assets/img/details.png"></a></li>
101             
103
104         </ul>
105         <div class="tab-content">
106             <div class="tab-pane active" role="tabpanel" id="tab-1">
107
108                 <p>
109                     <div class="table-responsive" >
110 
111                         <div class="container" style="width:100%">
112
113                                 <ul class="nav nav-tabs">
114                                   <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
115                                   <li ><a href="updatestudent.php">Update Existing Record <img src="assets/img/update2.png"> </a></li>
116                                   <li><a href="deletestudentrecord.php">Delete Record<img src="assets/img/delete2.png"></a></li>
117                                   <li ><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
118                                   <li><a href="importstudentlist.php">Import Data (CSV) <img src="assets/img/import.png"></a></li>
119                                   <li class="active"><a href="exportstudentlist.php">EXPORT Data (CSV) <img src="assets/img/export.png"></a></li>
120                                   <li><a href="searchstudent.php">Search <img src="assets/img/search.png"></a></li>
121                                   <li><a href="billingstudent.php">Billing </a></li>
122                                   <li><a href="studentcreditnotes.php">Credit Notes </a></li>
123                                 </ul>
124                             <br>
125
126                         </div>
127
128   
129                         <table class="table table-hover" >
130                             <tr><td colspan="3" style="height:0.2px;"><h4>Export Data</h4></td></tr>
131                             <tr>
132                             <td>Sir name<input type="text" name=""> Firstname Name<input type="text" name=""> Last Name<input type="text" name="">
133                                   ID/Passport NO.<input type="text" name=""><br><br>Date of Birth<input type="date" name="">
134                                   Gender <select name="gender">
135                                                   <option value="male">Male</option>
136                                                   <option value="female">Female</option>
137                                           </select>
138                                           Country<input type="text" name=""> County<input type="text" name=""> Town<input type="text" name="">
139
140                             </td></tr>
141                              <tr><td style=" height:0.2px;"><h4>Contact Details</h4></td></tr>
142                             <tr ><td>
143
144                                 Mobile    <input type="text" name=""> Email<input type="email" name="">
145
146                                 Address<input type="text" name="">
147                                 Zip Code <input type="text" name="">
148
149                             </td></tr>
150                              <tr><td style="height:0.2px;"><h4>Guardian/Parent and other Details</h4></td></tr>
151                             <tr><td>
152
153                                 Sir name  <input type="text" name=""> Firstname Name<input type="text" name=""> Last Name<input type="text" name=""><br><br>
154
155                                       Mobile     <input type="number" name="">Relationship     <input type="text" name="">
156
157
158                             </td></tr>
159                             <tr><td>
160                            <font color="orange" size="4"> Course Applied     <select name="">
161                                                     <option value="male">Information Technology</option>
162                                                     <option value="female">Business Management</option></select>
163                                     Assign Adm. No.     <input type="text" name="">
164                                     Assign Class/Intake     <select name="">
165                                                     <option value="male">Sep2017</option>
166                                                     <option value="female">Dec2017</option></select>
167                                     </font>
168
169                                    <input type="submit" name="submit" value="Save Record">
170
171                             </td></tr>
172
173
174
175                         </table>
176
177 
178
179
180                 </div>
181                 </p>
182
183
184             </div>
185
186         </div>
187     </div>
188
189     <div class="col-md-12" style="position: fixed;">
190         <p class="text-center text-danger">@J. Muthama Tel: +254729734768</p>
191     </div>
192     <script src="assets/js/jquery.min.js"></script>
193     <script src="assets/bootstrap/js/bootstrap.min.js"></script>
194     <script src="assets/js/affix.js"></script>
195     <script src="assets/js/alert.js"></script>
196     <script src="assets/js/alert1.js"></script>
197     <script src="assets/js/bootstrap.js"></script>
198     <script src="assets/js/bootstrap.min.js"></script>
199     <script src="assets/js/bootstrap-datepicker.js"></script>
200     <script src="assets/js/bootstrap-wysihtml5.js"></script>
201     <script src="assets/js/button.js"></script>
202     <script src="assets/js/carousel.js"></script>
203     <script src="assets/js/chosen.jquery.min.js"></script>
204     <script src="assets/js/ckeditor.js"></script>
205     <script src="assets/js/collapse.js"></script>
206     <script src="assets/js/color.js"></script>
207     <script src="assets/js/dropdown.js"></script>
208     <script src="assets/js/DT_bootstrap.js"></script>
209     <script src="assets/js/dynamic.js"></script>
210     <script src="assets/js/ie-emulation-modes-warning.js"></script>
211     <script src="assets/js/jquery.dataTables.js"></script>
212     <script src="assets/js/jquery.dataTables.min.js"></script>
213     <script src="assets/js/jquery.dialog.js"></script>
214     <script src="assets/js/jquery.hoverdir.js"></script>
215     <script src="assets/js/jquery.jgrowl.js"></script>
216     <script src="assets/js/jquery.knob.js"></script>
217     <script src="assets/js/jquery.uniform.min.js"></script>
218     <script src="assets/js/jquery-1.8.3.min.js"></script>
219     <script src="assets/js/jquery-1.9.1.js"></script>
220     <script src="assets/js/jquery-1.9.1.min.js"></script>
221     <script src="assets/js/jquery-1.10.2.js"></script>
222     <script src="assets/js/jquery-1.11.0.js"></script>
223     <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
224     <script src="assets/js/jquery-ui-1.10.3.js"></script>
225     <script src="assets/js/modal.js"></script>
226     <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
227     <script src="assets/js/myjquery.js"></script>
228     <script src="assets/js/myjquery1.js"></script>
229     <script src="assets/js/npm.js"></script>
230     <script src="assets/js/popover.js"></script>
231     <script src="assets/js/profile.js"></script>
232     <script src="assets/js/raphael-min.js"></script>
233     <script src="assets/js/sb-admin-2.js"></script>
234     <script src="assets/js/scripts.js"></script>
235     <script src="assets/js/scrollspy.js"></script>
236     <script src="assets/js/tab.js"></script>
237     <script src="assets/js/tooltip.js"></script>
238     <script src="assets/js/transition.js"></script>
239     <script src="assets/js/wysihtml5-0.3.0.js"></script>
240     <script language="javascript" type="text/javascript">
241      $(window).load(function()
242       {
243         $('#loading').hide();
244       });
245 </script>
246 </body>
247
248 </html>

Hệ thống quản lý trường học bằng PHP / MySQLi

Web, Tìm kiếm nhanh

Web, Tìm kết quả nhanh

Dự án liên quan!

Hình ảnh cập nhật PHP trong MySQL

PHP Chọn dữ liệu trong MySQL

Lựa chọn dữ liệu giới hạn PHP trong MySQL

PHP Chèn nhiều dữ liệu vào MySQL

PHP Chèn hình ảnh vào MySQL

PHP Nhận ID của dữ liệu được chèn lần cuối trong MySQL